EMT Practice Test

1. Question Content...

---

Question1: What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA?
Note: There are 2 correct answers to this question.

Question2: InfoObject CITY is defined as a display attribute for InfoObject CUSTOMER, and InfoObject COUNTRY is defined as a display attribute for InfoObject CITY. In a master data report you want to display the COUNTRY of a CUSTOMER.
Which options do you have to realize the scenario? Note: There are 3 correct answer to this question."

Question3: In which ODP context is the operational delta queue (ODQ) managed by the target system?

Question4: You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.

Question5: Which external hierarchy properties can be changed in the query definition?

Question6: Which features of an SAP BW/4HANA InfoObjet are intended to reduce the physical data volume?
Note: There are 2 correct answers to this question.

Question7: You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HANA.
Which options do you have to analyze a potential extractor issue? Note: There are 2 correct answers to this question.

Question8: You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different atribute values assigned.
How do you desing the model?

Question9: Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question

Question10: Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

Question11: What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this question.

Question12: For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus?? Note: There are 2 correct answers to this question.

Question13: You create a generic DataSource in SAP ERP. "How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?"

Question14: You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source.
Which tool can you use to create this analysis view?

Question15: What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?

Question16: Where can you automatically generate a process chain?

Question17: Which interface do you use to create a BW InfoObjet with access type "SAP HANA view!?

Question18: What are some of advantages of using SAP BW/4HANA business content? Note: There are 2 correct answers to this question.

Question19: You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

Question20: Which development object needs to be built to generate an HDI Container?

Question21: In an SAP HANA smart data integration flowgraph, which transformation options are available? Note:
There are 3 correct answers to this question.

Question22: "For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the high Cardinality flag." What is the effect on SID values in this scenario?

Question23: You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view.
Which kind of currency reference can be assigned to the measure? Note: There are 2 correct answers to this question.

Question24: Which variable types in a BW query can use the processing type SAP HANA Exit?

Question25: When loading master data for a material, you want to look at the new values before they are released for reporting.
What could you do using modeling features? Note: There are 2 correct answers to this question.

Question26: Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.

Question27: Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note:
There are 3 correct answers to this question.

Question28: How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.

Question29: Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question.

Question30: What is the purpose of an architecture overview model?

Question31: "You have already loaded data from a non-sap system into SAP Data Wharehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system" What do you need to use to combine data?

Question32: You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum.
Which Delta methods indicate that the DataSource provides consistent information for this target? Note:
There are 2 correct answers to this question.

Question33: Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

Question34: In a BW query with cells, you need to overwrite the initial definition of a cell.
With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.

Question35: With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework.
Which tecnical namespace is assigned to identify the new SAP ERP-related business content?

Question36: You want to define a restricted column in an SAP HANA calculation view.
What do you need to define? Note: There are 2 correct answers to this question.

Question37: Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (Advanced)? There are 2 correct answers to this question.

Question38: What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.

Question39: In the Web IDE for SAP HANA workspace, you have imported a project including an HDB module with calculation views.
What do you need to do in the project sittings before you can successfully build the HDB module?

Question40: Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are 3 correct answers to this question.

Question41: What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?

Question42: You use InfoObject B as a display attribute for InfoObject A.
Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correct nswers to this question."